package tech.aistar.mapper.services;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import tech.aistar.entity.Services;

import java.util.List;

/**
 * Created by Administrator on 2019/10/11 0011.
 */
public interface ServiceMapper {
    @Select("select * from services where userinfo_id = #{value}")
    List<Services> findId(Integer userinfoId);


    //添加1 收藏
    @Insert("insert into services(userinfo_id,province,city,url,status) values(#{userinfoId},#{province},#{city},#{url},#{status})")
    void sSave(Services services);

    //通过userinfo_id查找全部信息
    @Select("select * from services where userinfo_id = #{userinfo_id}")
    List<Services> findAll(Integer userinfoId);
}
